package com.jierui.meter.frontend.mapper;

import com.jierui.meter.frontend.domain.DO.TgDailyFreezeDO;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface TgDailyFreezeMapper {

    List<TgDailyFreezeDO> selectByTgIdOrderByTime(@Param("tgId") String tgId, @Param("orderByDateASC") Integer orderByDateASC, @Param("orderByDateDESC") Integer orderByDateDESC);

    List<TgDailyFreezeDO> selectListByTgIdAndTime(@Param("tgId") String tgId, @Param("datadate") String datadate);

    List<TgDailyFreezeDO> selectListByMeterIdOrTgid(@Param("meterId") String meterId, @Param("orderByDateDESC") Integer orderByDateDESC, @Param("tgid") String tgid);

    int selectListByMeterIdOrTgidCount(@Param("meterId") String meterId, @Param("orderByDateDESC") Integer orderByDateDESC, @Param("tgid") String tgid);

    List<TgDailyFreezeDO> selectPowerSumByTgidAndStartEnd(@Param("tgId") String tgId, @Param("startTime") String startTime, @Param("endTime") String endTime);
}
